{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import xlwings as xw\n",
    "import pandas as pd\n",
    "from pandas import DataFrame, Series\n",
    "import re\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2016.11月工资..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2016.12月工资汇总.xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.10月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.1月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.2月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.3月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.4月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.5月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.6月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.7月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.8月工资汇总..xlsx',\n",
       " 'F:\\\\文档\\\\森马\\\\恒金档案袋\\\\恒金工资表201610-201710\\\\2017.9月工资汇总..xlsx']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = r'F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710'\n",
    "path_lst = [os.path.join(path, i) for i in os.listdir(path)]\n",
    "path_lst"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "app = xw.App(visible=True, add_book=False)\n",
    "# xb = app.books.open(path_lst[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [1]\n",
       "Index: []"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# init_df = pd.DataFrame(columns=[1])\n",
    "# init_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def getOneTable():\n",
    "    frames = []\n",
    "    for i in range(1,4):\n",
    "        sheet = xb.sheets[i]\n",
    "        one = sheet.range('a2:aa300').options(pd.DataFrame).value\n",
    "        one.dropna(axis=0, how='any', thresh=3, inplace=True)\n",
    "        one.dropna(axis=1, how='all', inplace=True)\n",
    "    #     print(one)\n",
    "        frames.append(one)\n",
    "    init_df = pd.concat(frames, join='outer', axis=0)\n",
    "    return init_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2016.11月工资..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2016.12月工资汇总.xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.10月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.1月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.2月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.3月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.4月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.5月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.6月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.7月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.8月工资汇总..xlsx\n",
      "F:\\文档\\森马\\恒金档案袋\\恒金工资表201610-201710\\2017.9月工资汇总..xlsx\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Float64Index: 1717 entries, 1.0 to nan\n",
      "Data columns (total 30 columns):\n",
      "保底补贴    3 non-null float64\n",
      "入职时间    1681 non-null datetime64[ns]\n",
      "其他      5 non-null float64\n",
      "其它      27 non-null float64\n",
      "出勤天数    1681 non-null float64\n",
      "加班费     1095 non-null float64\n",
      "劳动纪律    25 non-null float64\n",
      "备注      312 non-null object\n",
      "姓名      1681 non-null object\n",
      "实发工资    1717 non-null float64\n",
      "实际补贴    14 non-null float64\n",
      "工作天数    1716 non-null float64\n",
      "工资      237 non-null float64\n",
      "应发工资    1717 non-null float64\n",
      "房补      502 non-null float64\n",
      "手续费     1717 non-null float64\n",
      "搬运费     57 non-null float64\n",
      "月份      1717 non-null object\n",
      "水电费     24 non-null float64\n",
      "社保      1085 non-null float64\n",
      "福利      68 non-null float64\n",
      "组别      1249 non-null object\n",
      "补贴      39 non-null float64\n",
      "计件      1717 non-null float64\n",
      "计件补贴    229 non-null float64\n",
      "计时      78 non-null float64\n",
      "请假天数    244 non-null float64\n",
      "车种      1681 non-null object\n",
      "车费补贴    80 non-null float64\n",
      "饭补      1717 non-null float64\n",
      "dtypes: datetime64[ns](1), float64(24), object(5)\n",
      "memory usage: 415.8+ KB\n"
     ]
    }
   ],
   "source": [
    "all_df = []\n",
    "for x in path_lst:\n",
    "    print(x)\n",
    "    xb = app.books.open(x)\n",
    "    one = getOneTable()\n",
    "    one['月份'] = x[-17:-10]\n",
    "    all_df.append(one)\n",
    "    xb.close()\n",
    "all_data = pd.concat(all_df, join='outer', axis=0)\n",
    "all_data.info()\n",
    "app.quit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "app.quit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "all_data.to_excel('d:\\\\恒金.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>保底补贴</th>\n",
       "      <th>入职时间</th>\n",
       "      <th>其他</th>\n",
       "      <th>其它</th>\n",
       "      <th>出勤天数</th>\n",
       "      <th>加班费</th>\n",
       "      <th>劳动纪律</th>\n",
       "      <th>备注</th>\n",
       "      <th>姓名</th>\n",
       "      <th>实发工资</th>\n",
       "      <th>...</th>\n",
       "      <th>福利</th>\n",
       "      <th>组别</th>\n",
       "      <th>补贴</th>\n",
       "      <th>计件</th>\n",
       "      <th>计件补贴</th>\n",
       "      <th>计时</th>\n",
       "      <th>请假天数</th>\n",
       "      <th>车种</th>\n",
       "      <th>车费补贴</th>\n",
       "      <th>饭补</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序号</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-05-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>73.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李先俊</td>\n",
       "      <td>4571.897342</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4454.697342</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-06-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>74.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李承强</td>\n",
       "      <td>4342.162475</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4231.962475</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2005-01-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>何波</td>\n",
       "      <td>4343.662475</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4231.962475</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-05-29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>周阳</td>\n",
       "      <td>4284.807700</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4161.107700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-08-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>胡二</td>\n",
       "      <td>4126.427608</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4009.227608</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-03-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>黎望红</td>\n",
       "      <td>4031.833661</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3920.133661</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-02-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>潘碧清</td>\n",
       "      <td>2309.256841</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2288.556841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>电剪</td>\n",
       "      <td>NaN</td>\n",
       "      <td>152.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-09-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>114.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>高由莲</td>\n",
       "      <td>4962.525000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4808.325000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>查片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-07-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>72.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李能会</td>\n",
       "      <td>3801.446364</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3733.246364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>查片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2004-05-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>贾麦丽</td>\n",
       "      <td>4474.840682</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4369.140682</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>查片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>751.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>41248.860148</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40208.360148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2132.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-11-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>81.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>何安乐</td>\n",
       "      <td>1203.195818</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1089.995818</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>冚车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>216.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-04-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>黄启茂</td>\n",
       "      <td>2272.796818</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2139.096818</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-04-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>92.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李秋华</td>\n",
       "      <td>3236.480000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2945.880000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>216.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-02-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>79.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>刘凡群</td>\n",
       "      <td>2156.905000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2029.705000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-06-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>66.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>齐海蓉</td>\n",
       "      <td>2635.140000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2520.940000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>孙伟</td>\n",
       "      <td>3549.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3435.800000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>冚车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-04-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>83.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>王小军</td>\n",
       "      <td>1744.340000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1613.140000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-11-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>79.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杜凤霞</td>\n",
       "      <td>4049.502000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3922.302000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-04-28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.5</td>\n",
       "      <td>72.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>黄长丽</td>\n",
       "      <td>3072.788182</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2957.088182</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>95.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李长友</td>\n",
       "      <td>3926.250000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3616.650000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>冚车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-03-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>93.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李万好</td>\n",
       "      <td>1761.695000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1620.495000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>73.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李文龙</td>\n",
       "      <td>3696.220000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3575.020000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>冚车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-04-07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>79.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>谢模杰</td>\n",
       "      <td>2651.810000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2349.310000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尹秋美</td>\n",
       "      <td>4541.200000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4420.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.5</td>\n",
       "      <td>76.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>翟磊</td>\n",
       "      <td>2393.545955</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2281.845955</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.5</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-03-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>81.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张斌</td>\n",
       "      <td>2853.900000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2724.700000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>冚车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>91.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>汪胜利</td>\n",
       "      <td>3267.720000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3136.520000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>94.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张帆</td>\n",
       "      <td>2843.220000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2737.020000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>平车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-04-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.5</td>\n",
       "      <td>86.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张雄</td>\n",
       "      <td>2882.585000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2752.385000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>边车</td>\n",
       "      <td>NaN</td>\n",
       "      <td>228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-12-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>梁家娟</td>\n",
       "      <td>3467.553000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3272.053000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>58.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李玉兰</td>\n",
       "      <td>3330.408000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3131.408000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3303.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>467628.541990</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>422278.551628</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28265.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-12-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>胡昌伟</td>\n",
       "      <td>3446.280000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3241.780000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>专机</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2005-03-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>高柏林</td>\n",
       "      <td>5376.220000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5170.720000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大烫</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2005-03-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>45.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>毛世远</td>\n",
       "      <td>5556.170000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5320.170000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大烫</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-02-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>唐忠有</td>\n",
       "      <td>4330.240000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4185.740000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大烫</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-02-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>陶香菊</td>\n",
       "      <td>4431.230000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4015.230000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大烫</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-02-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>吴康现</td>\n",
       "      <td>6046.578028</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4067.678028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大烫</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-12-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>郭银库</td>\n",
       "      <td>6004.334131</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4092.134131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-07-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>林军</td>\n",
       "      <td>5658.574131</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4048.574131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>260.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-10-07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>严发</td>\n",
       "      <td>3703.786900</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3515.286900</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>大包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-05-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>严子仁</td>\n",
       "      <td>3961.178028</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3773.678028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>大包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-04-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.5</td>\n",
       "      <td>48.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>陈青连</td>\n",
       "      <td>4097.476579</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3729.476579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>小包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>275.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>胡晶晶</td>\n",
       "      <td>4031.274131</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3734.774131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>包挂</td>\n",
       "      <td>NaN</td>\n",
       "      <td>260.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-03-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.5</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>肖莲英</td>\n",
       "      <td>4066.774131</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3734.774131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>小包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>275.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-03-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>谢艳红</td>\n",
       "      <td>3746.479396</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3241.379396</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>包挂</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-01-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>杨玖梅</td>\n",
       "      <td>5386.800000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4107.800000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>包挂</td>\n",
       "      <td>NaN</td>\n",
       "      <td>290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-04-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>袁友风</td>\n",
       "      <td>5356.540000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4084.040000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>小包</td>\n",
       "      <td>NaN</td>\n",
       "      <td>290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-04-29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>黎定花</td>\n",
       "      <td>4069.762222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3014.262222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>前查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-10-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>65.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>李几云</td>\n",
       "      <td>3975.172222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2929.172222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>前查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-02-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>70.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>尹小勇</td>\n",
       "      <td>4252.772222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3030.172222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-03-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>曾美英</td>\n",
       "      <td>3921.232222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2674.232222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-06-27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>程自英</td>\n",
       "      <td>3874.742222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2637.742222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-04-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>66.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>肖翠玲</td>\n",
       "      <td>3663.392222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2471.892222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-10-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>57.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>徐电君</td>\n",
       "      <td>3324.362222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2101.862222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-03-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>杨云彦</td>\n",
       "      <td>3204.392222</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2202.892222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-05-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*</td>\n",
       "      <td>钟小红</td>\n",
       "      <td>2081.860000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>870.760000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>*</td>\n",
       "      <td>钟秀枚</td>\n",
       "      <td>2015.900000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2504.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尾查</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1644.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>109583.523232</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88500.223232</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7220.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1717 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        保底补贴       入职时间  其他   其它  出勤天数     加班费  劳动纪律    备注    姓名  \\\n",
       "序号                                                                 \n",
       " 1.0     NaN 2014-05-25 NaN  NaN  30.0    73.5   NaN   NaN   李先俊   \n",
       " 2.0     NaN 2013-06-21 NaN  NaN  30.0    74.5   NaN   NaN   李承强   \n",
       " 3.0     NaN 2005-01-14 NaN  NaN  30.0    72.0   NaN   NaN    何波   \n",
       " 4.0     NaN 2015-05-29 NaN  NaN  30.0    76.0   NaN   NaN    周阳   \n",
       " 5.0     NaN 2014-08-23 NaN  NaN  30.0    77.5   NaN   NaN    胡二   \n",
       " 6.0     NaN 2014-03-10 NaN  NaN  30.0    72.0   NaN   NaN   黎望红   \n",
       " 7.0     NaN 2014-02-18 NaN  NaN  20.0    53.0   NaN   NaN   潘碧清   \n",
       " 8.0     NaN 2009-09-19 NaN  NaN  30.0   114.5   NaN   NaN   高由莲   \n",
       " 9.0     NaN 2009-07-08 NaN  NaN  24.0    72.5   NaN   NaN   李能会   \n",
       " 10.0    NaN 2004-05-01 NaN  NaN  30.0    66.0   NaN   NaN   贾麦丽   \n",
       "NaN      NaN        NaT NaN  NaN   NaN   751.5   NaN   NaN  None   \n",
       " 1.0     NaN 2010-11-15 NaN  NaN  28.0    81.5   NaN   NaN   何安乐   \n",
       " 2.0     NaN 2014-04-01 NaN  NaN  30.0    86.0   NaN   NaN   黄启茂   \n",
       " 3.0     NaN 2014-04-17 NaN  NaN  28.0    92.5   NaN   NaN   李秋华   \n",
       " 4.0     NaN 2012-02-10 NaN  NaN  30.0    79.5   NaN   NaN   刘凡群   \n",
       " 5.0     NaN 2007-06-03 NaN  NaN  30.0    66.5   NaN   NaN   齐海蓉   \n",
       " 6.0     NaN 2016-04-12 NaN  NaN  29.0    74.0   NaN   NaN    孙伟   \n",
       " 7.0     NaN 2014-04-03 NaN  NaN  30.0    83.5   NaN   NaN   王小军   \n",
       " 8.0     NaN 2010-11-05 NaN  NaN  30.0    79.5   NaN   NaN   杜凤霞   \n",
       " 9.0     NaN 2015-04-28 NaN  NaN  29.5    72.0   NaN   NaN   黄长丽   \n",
       " 10.0    NaN 2016-03-01 NaN  NaN  30.0    95.5   NaN   NaN   李长友   \n",
       " 11.0    NaN 2011-03-04 NaN  NaN  30.0    93.5   NaN   NaN   李万好   \n",
       " 12.0    NaN 2016-03-14 NaN  NaN  30.0    73.5   NaN   NaN   李文龙   \n",
       " 13.0    NaN 2014-04-07 NaN  NaN  30.0    79.5   NaN   NaN   谢模杰   \n",
       " 14.0    NaN 2016-03-09 NaN  NaN  30.0    73.0   NaN   NaN   尹秋美   \n",
       " 15.0    NaN 2016-03-11 NaN  NaN  28.5    76.0   NaN   NaN    翟磊   \n",
       " 16.0    NaN 2015-03-10 NaN  NaN  30.0    81.5   NaN   NaN    张斌   \n",
       " 17.0    NaN 2016-03-25 NaN  NaN  29.0    91.5   NaN   NaN   汪胜利   \n",
       " 18.0    NaN 2016-04-25 NaN  NaN  30.0    94.5   NaN   NaN    张帆   \n",
       " 19.0    NaN 2014-04-01 NaN  NaN  29.5    86.5   NaN   NaN    张雄   \n",
       "...      ...        ...  ..  ...   ...     ...   ...   ...   ...   \n",
       " 103.0   NaN 2014-12-08 NaN  NaN  30.0    55.0   NaN   NaN   梁家娟   \n",
       " 104.0   NaN 2016-03-05 NaN  NaN  30.0    58.5   NaN   NaN   李玉兰   \n",
       "NaN      NaN        NaT NaN  NaN   NaN  3303.0   NaN   NaN  None   \n",
       " 1.0     NaN 2016-12-10 NaN  NaN  30.0    64.0   NaN     *   胡昌伟   \n",
       " 2.0     NaN 2005-03-24 NaN  NaN  30.0    65.0   NaN     *   高柏林   \n",
       " 3.0     NaN 2005-03-24 NaN  NaN  30.0    45.5   NaN     *   毛世远   \n",
       " 4.0     NaN 2009-02-06 NaN  NaN  30.0    54.0   NaN     *   唐忠有   \n",
       " 5.0     NaN 2011-02-18 NaN  NaN  30.0    41.0   NaN     *   陶香菊   \n",
       " 6.0     NaN 2011-02-15 NaN  NaN  30.0    92.0   NaN     *   吴康现   \n",
       " 7.0     NaN 2016-12-12 NaN  NaN  30.0    87.0   NaN     *   郭银库   \n",
       " 8.0     NaN 2016-07-14 NaN  NaN  28.0    79.0   NaN     *    林军   \n",
       " 9.0     NaN 2008-10-07 NaN  NaN  30.0    48.0   NaN     *    严发   \n",
       " 10.0    NaN 2016-05-16 NaN  NaN  30.0    47.0   NaN     *   严子仁   \n",
       " 11.0    NaN 2015-04-03 NaN  NaN  29.5    48.0   NaN     *   陈青连   \n",
       " 12.0    NaN 2015-04-11 NaN  NaN  28.0    46.0   NaN     *   胡晶晶   \n",
       " 13.0    NaN 2015-03-01 NaN  NaN  29.5    59.0   NaN     *   肖莲英   \n",
       " 14.0    NaN 2015-03-02 NaN  NaN  30.0    53.0   NaN     *   谢艳红   \n",
       " 15.0    NaN 2009-01-19 NaN  NaN  30.0    74.0   NaN     *   杨玖梅   \n",
       " 16.0    NaN 2013-04-19 NaN  NaN  30.0    67.5   NaN     *   袁友风   \n",
       " 17.0    NaN 2010-04-29 NaN  NaN  30.0    75.0   NaN     *   黎定花   \n",
       " 18.0    NaN 2010-10-13 NaN  NaN  30.0    65.5   NaN     *   李几云   \n",
       " 19.0    NaN 2016-02-21 NaN  NaN  30.0    70.5   NaN     *   尹小勇   \n",
       " 20.0    NaN 2014-03-06 NaN  NaN  30.0    82.0   NaN     *   曾美英   \n",
       " 21.0    NaN 2009-06-27 NaN  NaN  30.0    72.0   NaN     *   程自英   \n",
       " 22.0    NaN 2014-04-06 NaN  NaN  29.0    66.5   NaN     *   肖翠玲   \n",
       " 23.0    NaN 2015-10-09 NaN  NaN  30.0    57.5   NaN     *   徐电君   \n",
       " 24.0    NaN 2015-03-17 NaN  NaN  30.0    61.0   NaN     *   杨云彦   \n",
       " 25.0    NaN 2013-05-20 NaN  NaN  30.0    59.0   NaN     *   钟小红   \n",
       " 26.0    NaN 2015-07-01 NaN  NaN  30.0    65.0  15.0     *   钟秀枚   \n",
       "NaN      NaN        NaT NaN  0.0   NaN  1644.0  15.0  None  None   \n",
       "\n",
       "                 实发工资   ...     福利    组别  补贴             计件  计件补贴  计时  请假天数  \\\n",
       "序号                      ...                                                   \n",
       " 1.0      4571.897342   ...    NaN   NaN NaN    4454.697342   NaN NaN   NaN   \n",
       " 2.0      4342.162475   ...    NaN   NaN NaN    4231.962475   NaN NaN   NaN   \n",
       " 3.0      4343.662475   ...    NaN   NaN NaN    4231.962475   NaN NaN   NaN   \n",
       " 4.0      4284.807700   ...    NaN   NaN NaN    4161.107700   NaN NaN   NaN   \n",
       " 5.0      4126.427608   ...    NaN   NaN NaN    4009.227608   NaN NaN   NaN   \n",
       " 6.0      4031.833661   ...    NaN   NaN NaN    3920.133661   NaN NaN   NaN   \n",
       " 7.0      2309.256841   ...    NaN   NaN NaN    2288.556841   NaN NaN  10.0   \n",
       " 8.0      4962.525000   ...    NaN   NaN NaN    4808.325000   NaN NaN   NaN   \n",
       " 9.0      3801.446364   ...    NaN   NaN NaN    3733.246364   NaN NaN   6.0   \n",
       " 10.0     4474.840682   ...    NaN   NaN NaN    4369.140682   NaN NaN   NaN   \n",
       "NaN      41248.860148   ...    NaN   NaN NaN   40208.360148   NaN NaN   NaN   \n",
       " 1.0      1203.195818   ...    NaN     2 NaN    1089.995818   NaN NaN   2.0   \n",
       " 2.0      2272.796818   ...    NaN     2 NaN    2139.096818   NaN NaN   NaN   \n",
       " 3.0      3236.480000   ...    NaN     2 NaN    2945.880000   NaN NaN   2.0   \n",
       " 4.0      2156.905000   ...    NaN     2 NaN    2029.705000   NaN NaN   NaN   \n",
       " 5.0      2635.140000   ...    NaN     2 NaN    2520.940000   NaN NaN   NaN   \n",
       " 6.0      3549.500000   ...    NaN     2 NaN    3435.800000   NaN NaN   1.0   \n",
       " 7.0      1744.340000   ...    NaN     2 NaN    1613.140000   NaN NaN   NaN   \n",
       " 8.0      4049.502000   ...    NaN     2 NaN    3922.302000   NaN NaN   NaN   \n",
       " 9.0      3072.788182   ...    NaN     2 NaN    2957.088182   NaN NaN   0.5   \n",
       " 10.0     3926.250000   ...    NaN     2 NaN    3616.650000   NaN NaN   NaN   \n",
       " 11.0     1761.695000   ...    NaN     2 NaN    1620.495000   NaN NaN   NaN   \n",
       " 12.0     3696.220000   ...    NaN     2 NaN    3575.020000   NaN NaN   NaN   \n",
       " 13.0     2651.810000   ...    NaN     2 NaN    2349.310000   NaN NaN   NaN   \n",
       " 14.0     4541.200000   ...    NaN     2 NaN    4420.500000   NaN NaN   NaN   \n",
       " 15.0     2393.545955   ...    NaN     2 NaN    2281.845955   NaN NaN   1.5   \n",
       " 16.0     2853.900000   ...    NaN     2 NaN    2724.700000   NaN NaN   NaN   \n",
       " 17.0     3267.720000   ...    NaN     2 NaN    3136.520000   NaN NaN   1.0   \n",
       " 18.0     2843.220000   ...    NaN     2 NaN    2737.020000   NaN NaN   NaN   \n",
       " 19.0     2882.585000   ...    NaN     2 NaN    2752.385000   NaN NaN   0.5   \n",
       "...               ...   ...     ..   ...  ..            ...   ...  ..   ...   \n",
       " 103.0    3467.553000   ...    NaN    中查 NaN    3272.053000   NaN NaN   NaN   \n",
       " 104.0    3330.408000   ...    NaN    中查 NaN    3131.408000   NaN NaN   NaN   \n",
       "NaN     467628.541990   ...    NaN  None NaN  422278.551628   NaN NaN   NaN   \n",
       " 1.0      3446.280000   ...    NaN   NaN NaN    3241.780000   NaN NaN   NaN   \n",
       " 2.0      5376.220000   ...    NaN   NaN NaN    5170.720000   NaN NaN   NaN   \n",
       " 3.0      5556.170000   ...    NaN   NaN NaN    5320.170000   NaN NaN   NaN   \n",
       " 4.0      4330.240000   ...    NaN   NaN NaN    4185.740000   NaN NaN   NaN   \n",
       " 5.0      4431.230000   ...    NaN   NaN NaN    4015.230000   NaN NaN   NaN   \n",
       " 6.0      6046.578028   ...    NaN   NaN NaN    4067.678028   NaN NaN   NaN   \n",
       " 7.0      6004.334131   ...    NaN   NaN NaN    4092.134131   NaN NaN   NaN   \n",
       " 8.0      5658.574131   ...    NaN   NaN NaN    4048.574131   NaN NaN   NaN   \n",
       " 9.0      3703.786900   ...    NaN   NaN NaN    3515.286900   NaN NaN   NaN   \n",
       " 10.0     3961.178028   ...    NaN   NaN NaN    3773.678028   NaN NaN   2.0   \n",
       " 11.0     4097.476579   ...    NaN   NaN NaN    3729.476579   NaN NaN   NaN   \n",
       " 12.0     4031.274131   ...    NaN   NaN NaN    3734.774131   NaN NaN   NaN   \n",
       " 13.0     4066.774131   ...    NaN   NaN NaN    3734.774131   NaN NaN   0.5   \n",
       " 14.0     3746.479396   ...    NaN   NaN NaN    3241.379396   NaN NaN   2.0   \n",
       " 15.0     5386.800000   ...    NaN   NaN NaN    4107.800000   NaN NaN   0.5   \n",
       " 16.0     5356.540000   ...    NaN   NaN NaN    4084.040000   NaN NaN   NaN   \n",
       " 17.0     4069.762222   ...    NaN   NaN NaN    3014.262222   NaN NaN   NaN   \n",
       " 18.0     3975.172222   ...    NaN   NaN NaN    2929.172222   NaN NaN   NaN   \n",
       " 19.0     4252.772222   ...    NaN   NaN NaN    3030.172222   NaN NaN   NaN   \n",
       " 20.0     3921.232222   ...    NaN   NaN NaN    2674.232222   NaN NaN   NaN   \n",
       " 21.0     3874.742222   ...    NaN   NaN NaN    2637.742222   NaN NaN   NaN   \n",
       " 22.0     3663.392222   ...    NaN   NaN NaN    2471.892222   NaN NaN   NaN   \n",
       " 23.0     3324.362222   ...    NaN   NaN NaN    2101.862222   NaN NaN   NaN   \n",
       " 24.0     3204.392222   ...    NaN   NaN NaN    2202.892222   NaN NaN   1.0   \n",
       " 25.0     2081.860000   ...    NaN   NaN NaN     870.760000   NaN NaN   NaN   \n",
       " 26.0     2015.900000   ...    NaN   NaN NaN    2504.000000   NaN NaN   NaN   \n",
       "NaN     109583.523232   ...    NaN   NaN NaN   88500.223232   NaN NaN   NaN   \n",
       "\n",
       "          车种  车费补贴       饭补  \n",
       "序号                           \n",
       " 1.0      电剪   NaN    228.0  \n",
       " 2.0      电剪   NaN    220.0  \n",
       " 3.0      电剪   NaN    224.0  \n",
       " 4.0      电剪   NaN    232.0  \n",
       " 5.0      电剪   NaN    224.0  \n",
       " 6.0      电剪   NaN    224.0  \n",
       " 7.0      电剪   NaN    152.0  \n",
       " 8.0      查片   NaN    224.0  \n",
       " 9.0      查片   NaN    180.0  \n",
       " 10.0     查片   NaN    224.0  \n",
       "NaN     None   NaN   2132.0  \n",
       " 1.0      冚车   NaN    216.0  \n",
       " 2.0      边车   NaN    232.0  \n",
       " 3.0      平车   NaN    216.0  \n",
       " 4.0      平车   NaN    232.0  \n",
       " 5.0      平车   NaN    232.0  \n",
       " 6.0      冚车   NaN    224.0  \n",
       " 7.0      边车   NaN    232.0  \n",
       " 8.0      边车   NaN    232.0  \n",
       " 9.0      平车   NaN    228.0  \n",
       " 10.0     冚车   NaN    232.0  \n",
       " 11.0     平车   NaN    232.0  \n",
       " 12.0     冚车   NaN    232.0  \n",
       " 13.0     边车   NaN    228.0  \n",
       " 14.0     平车   NaN    232.0  \n",
       " 15.0     边车   NaN    220.0  \n",
       " 16.0     冚车   NaN    232.0  \n",
       " 17.0     边车   NaN    224.0  \n",
       " 18.0     平车   NaN    232.0  \n",
       " 19.0     边车   NaN    228.0  \n",
       "...      ...   ...      ...  \n",
       " 103.0    中查   NaN    280.0  \n",
       " 104.0    中查   NaN    280.0  \n",
       "NaN     None   NaN  28265.0  \n",
       " 1.0      专机   NaN    280.0  \n",
       " 2.0      大烫   NaN    280.0  \n",
       " 3.0      大烫   NaN    280.0  \n",
       " 4.0      大烫   NaN    280.0  \n",
       " 5.0      大烫   NaN    280.0  \n",
       " 6.0      大烫   NaN    280.0  \n",
       " 7.0      大包   NaN    270.0  \n",
       " 8.0      大包   NaN    260.0  \n",
       " 9.0      大包   NaN    280.0  \n",
       " 10.0     大包   NaN    280.0  \n",
       " 11.0     小包   NaN    275.0  \n",
       " 12.0     包挂   NaN    260.0  \n",
       " 13.0     小包   NaN    275.0  \n",
       " 14.0     包挂   NaN    280.0  \n",
       " 15.0     包挂   NaN    290.0  \n",
       " 16.0     小包   NaN    290.0  \n",
       " 17.0     前查   NaN    280.0  \n",
       " 18.0     前查   NaN    280.0  \n",
       " 19.0     尾查   NaN    280.0  \n",
       " 20.0     尾查   NaN    280.0  \n",
       " 21.0     尾查   NaN    280.0  \n",
       " 22.0     尾查   NaN    270.0  \n",
       " 23.0     尾查   NaN    280.0  \n",
       " 24.0     尾查   NaN    270.0  \n",
       " 25.0     尾查   NaN    280.0  \n",
       " 26.0     尾查   NaN    280.0  \n",
       "NaN     None   NaN   7220.0  \n",
       "\n",
       "[1717 rows x 30 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
